[dbo].[asi_GroupMemberKeyByGroupRole]

SQLServer > iMIS1521GA > Stored Procedures > dbo.asi_GroupMemberKeyByGroupRole

Properties
Parameters
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On

Parameters

Name	Data Type	Max Length (Bytes)
@groupKey	uniqueidentifier	16
@roleKey	uniqueidentifier	16

SQL Script

CREATE PROCEDURE [dbo].[asi_GroupMemberKeyByGroupRole] (@groupKey uniqueidentifier, @roleKey uniqueidentifier)
AS
BEGIN

SELECT gm.GroupMemberKey, gm.MemberContactKey
FROM GroupMember gm INNER JOIN GroupMemberDetail gmd ON gm.GroupMemberKey = gmd.GroupMemberKey
WHERE gm.GroupKey=@groupKey AND gmd.GroupRoleKey=@roleKey
ORDER BY gmd.EffectiveDate DESC

END

GO

Uses

[dbo].[GroupMember]
[dbo].[GroupMemberDetail]
dbo